iLoADER

HOME

Error Messages

Cannot Assign <value> to variable <variable name>

Parsing set within Data Transformation script.

Cannot Copy File <FromPath>

CopyFile function was unable to copy the file.

Cannot Create Bespoke Loader Class

 iLoader was unable to create an instance of the injected DLL.

Cannot Create Expression <ObjectName>

Expression function could not create the expression.

Cannot Create Field <FieldName>

AddField function could not add the field.

Cannot Delete File <FromPath>

DeleteFile function was unable to delete the file.

Cannot Delete Set

Configuration Screen - Delete script set button. Occurs when the script set is read only.

Cannot Evaluate NSQL

 DumpDomain/DumpDomainFile function was unable to evaluate the NSQL.

Cannot Execute <file> Error

 When executing a batch command.

Cannot Find Database

Multidrop function was unable to find the database.

Cannot Find Domain <domain name>

Invertdomain function could not find the domain.

Cannot Find Object <ObjectName> In Link

 DropLink/ Link Function was unable to find the object to be linked.

Cannot Find Table <FullTable>

AddField/Aggregate/Expression function could not find the table.

Cannot Find Target Column

Decode function could not find the target column.

Cannot Move File <FromPath>

MoveFile function was unable to move the file.

Cannot Open File <FileName>

Decode function was unable to open the decode file.

Cannot Start Engine

iLoader was unable to start up or load Engine.

Could Not Find User <owner> Adding Table <table name> as SYSTEM

 Attempted to add a table for a user that does not exist.

Could Not Instantiate Server

 An error occurred trying to start the iLoader server.

Could Not Make <object name> Permanent

Engine was unable to handle the request to make the object permanent.

Data directory is empty

Table Declaration screen - there are no data files available, so the wizard is not shown.

DataFile Not Found or read only for Table

A data file was not found, please check that it exists.

DataFileList Entry <table script name> Not Found Or Read Only For Table <table name>

Occurs when table definition script does not exist, which is referenced in the table declaration.

Did Not Encounter label <label name> for GOTO

Occurs when a GOTO <label> is used without a matching label name.

Do not know ON <type>

Occurs when type is not either GOTO, STOP, RESUME.

ELSE without condition

ELSE needs a condition too.

End Block Mismatch

Occurs when there is a mismatch. Parsing table declarations within Data Transformation Scripts.

ENDIF without condition

ENDIF has been used without a matching If statement.

ERROR - Script "Scriptname" not found

Start-up parameter specified a script, but it doesn't exist.

Error Adding File

Unable to import data.

Error Creating Field

A function has tried to create a field, but was unsuccessful.

Error Creating Table

A function has tried to create a table, but was unsuccessful.

Error In Aggregate Filter

Aggregate function - The sql produced no results.

Error In Datafile List <parameter>

An invalid parameter has been used in the Datafile list.

Error In Inline Datafile List <parameter>

An invalid parameter has been used in the Inline Datafile list. Usually caused by the parameters not being encapsulated in {}.

Error Opening Control File / Link Script File / PostLoad Script File / Preload Script File / Table Load Script File / Transformation Data Script File

iLoader was unable to open the file.

Error Reading From Control File

Parsing control file - either upon executing the scripts.

Error Reading From File

Unable to Preload / TableLoad/ Link / Data Transformation Script File.

Error Reading Out Block

iLoader was unable to load the tokens from the script file.

Error Setting File Format

Unable to set the importer file format.

Error Setting Layout For Field <field name>

Unable to set the field width or ordinal position. The field name must be more than 2 characters.

Error Setting Update Key

An Update import is taking place, but the selected key is invalid.

Failed Creating Aggregate

Aggregate function - Creating the aggregate failed - error came back from engine.

General Error Importing

An unrecognized error has occurred. Contact the Support. If possible Cerlog and script files should be mailed to the help desk for analysis.

Invalid Date Parameter

Occurs when an invalid date is used, either in a table declaration or when using the Tdate function.

Invalid DELIMITER <Delimiter> in Table

An Invalid delimiter was used within the Table Declaration.

Invalid Entry In Table Definition

An invalid command / parameter has been used.

Invalid FIELD TYPE <FieldType> in Table

An invalid field type was used within a table definition script.

Invalid FORMAT <Format type> in Table

Error occurred within a table declaration. Format types are FLAT / DELIMITED / BESPOKE.

Invalid Number of parameters in ADDFIELD

Dependent on requirements, you must use 6, 7 or 8 parameters.

Invalid Number Of Parameters In DATA_AUDIT

DataAudit accepts no parameters.

Invalid Parameter In KEY / Sample Size / SOURCETABLE / TABLE

An invalid parameter was used with a keyword in the table declaration.

Invalid QUALIFIER <Qualifier> in Table

A qualifier other than was used.

Invalid Token <Token>

When the control file is being parsed, an invalid token was found.

Invalid Type Parameter

Invalid type used in TABLEDECLARATION valid types are REFRESH, AMEND, UPDATE.

Key Not Found

The field does not exist in database.

Missing DATE / DATFILE / END TABLE_DECLARATION / SCRIPTFILE / TYPE / WIDTH / Parameter entry

Parsing control file - Table Declaration errors. All errors mean parameters are missing.

No Domain In SQL

DumpDomain / DumpDomainFile - the NSQL produced no results.

No Module Specified For BESPOKE Filter

Bespoke was used as format type, but no parameters were supplied.

No Sheet View Of Column

Decode Function. No sheet view was available.

No Such Function <function name>

Attempted to use a function within Data Transformations script, which does not exist.

No Type Specified For BESPOKE Filter

Bespoke was used as format type, but the type was not specified.

Parameter Error In BACKUP

Parsing Preload Script File.

Parameter Error In BATCH command

Batch unable to execute.

Parameter Error In BUILD_KEY

Parsing Preload Script File.

Parameter Error In DROP

Parsing Preload Script File.

PRECISION must be 1 to 6

A number outside of the range 1 to 6 was used.

Script is read only. It is too long to be edited in iLoader.

Scripts Screen. If the file is over 64k in size, iLoader will not edit it.

Script Path does not exist

Configuration Screen - CreateFiles button. The script path detailed in the configuration screen does not exist.

Scripts directory is empty

Table Declaration screen

- there are no table definition scripts, so the wizard is not shown.

StartupError Name in Class conflicts with ExtendedFunctionCommand in ExtendedFunctionClass

Bespoke Function call failed. This is because there is a mismatch in the name used in the DLL and that referenced in the script.

Stopping Execution due to error

"on error stop" used in Data Transformation scripts, execution has stopped due to an error.

Table Already Exists Or Is Invalid

A function has attempted to either create a table, which exists or an invalid table name has been specified.

Transformation Data Execution Stopped

An error has occurred in the Data Transformation script and the process causing the error has stopped.

Unable to backup directory

Backup Function failed.

Unable to create CONTROL.TXT / DATATRANS.TXT / LINKSCRIPT.TXT / POSTLOAD.TXT / PRELOAD.TXT

Configuration Screen - CreateFiles button. Caused when iLoader is unable to generate the file.

Unknown Aggregate Type <AgType>

Aggregate function did not recognize the aggregate type.

Unknown Block Type

Occurs if BEGIN is not followed by TABLE_DECLARATION. Parsing table declarations within Data Transformation Scripts.

Unrecognized Command

Parsing Preload / Table Declaration Script File.

Unrecognized Statement In Link File

Parsing LinkScript file.

Unrecognized SubToken

A script error has occurred, where the command contains invalid parameters.

Unrecognized Transformation Data type

 Invalid command was used. Data Transformation Execution stopped.

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice